Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

Run Stored-Proc statement execution with the LOAD-RESULT-INTO phrase

Progress also supports a stored procedure implementation you can execute to obtain result sets and load these results into temp-tables. You must define result set(s) target as part of the RUN STORED-PROC statement. You do not explicitly close a RUN STORED_PROC defined this way as you do with buffer methods of retrieving result sets; the LOAD-RESULT-INTO function achieves this goal implicitly.

This is the syntax for the RUN STORED–PROC statement implementation when loading result sets to temp-tables:

Syntax

RUN STORED-PROC procedure-name [[LOAD-RESULT-INTO <handle> [<int> = PROC-STATUS]]      [NO-ERROR]     [([INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression, ...         [INPUT|OUTPUT|INPUT OUTPUT] [PARAM parameter-name =]expression)]

The RUN STORED-PROC statement sets up the execution of the stored-procedure, retrieves the result set(s), and loads it into the temp-table(s) provided you use the LOAD-RESULT-INTO function. The CLOSE STORED-PROC statement is automatically applied when the result set(s) is loaded into temp-tables because using temp-tables must consume all result sets of the procedure.